Pandas Profiling Report

Dataset statistics

Number of variables	24
Number of observations	13644
Missing cells	67159
Missing cells (%)	20.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.1 MiB
Average record size in memory	241.0 B

Variable types

NUM	12
CAT	11
BOOL	1

Reproduction

Analysis started	2020-06-03 05:46:12.258482
Analysis finished	2020-06-03 05:47:18.854152
Duration	1 minute and 6.6 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`state` has constant value "WA"	Constant
`propertyName` has a high cardinality: 697 distinct values	High cardinality
`street` has a high cardinality: 697 distinct values	High cardinality
`neighborhood` has a high cardinality: 87 distinct values	High cardinality
`unit` has a high cardinality: 1726 distinct values	High cardinality
`name` has a high cardinality: 4476 distinct values	High cardinality
`rent` has 4132 (30.3%) missing values	Missing
`sqft` has 213 (1.6%) missing values	Missing
`deposit` has 13452 (98.6%) missing values	Missing
`unit` has 9113 (66.8%) missing values	Missing
`leaseLength` has 13480 (98.8%) missing values	Missing
`name` has 335 (2.5%) missing values	Missing
`new` has 13121 (96.2%) missing values	Missing
`applyNow` has 13309 (97.5%) missing values	Missing
`Unnamed: 0_x` has 178 (1.3%) zeros	Zeros
`reviewScore` has 9224 (67.6%) zeros	Zeros
`reviewCount` has 5516 (40.4%) zeros	Zeros
`transitScore` has 212 (1.6%) zeros	Zeros

Unnamed: 0_x
Real number (ℝ_≥0)

ZEROS

Distinct count	752
Unique (%)	5.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	239.02059513339196
Minimum	0
Maximum	751
Zeros	178
Zeros (%)	1.3%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	58
median	161
Q3	365.25
95-th percentile	711
Maximum	751
Range	751
Interquartile range (IQR)	307.25

Descriptive statistics

Standard deviation	223.0319473
Coefficient of variation (CV)	0.9331076562
Kurtosis	-0.2335259764
Mean	239.0205951
Median Absolute Deviation (MAD)	119
Skewness	0.982545378
Sum	3261197
Variance	49743.24952

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
67	220	1.6%
734	220	1.6%
61	200	1.5%
699	200	1.5%
0	178	1.3%
362	178	1.3%
57	158	1.2%
676	158	1.2%
6	157	1.2%
63	148	1.1%
Other values (742)	11827	86.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	178	1.3%
1	40	0.3%
2	68	0.5%
3	26	0.2%
4	54	0.4%

Value	Count	Frequency (%)
751	8	0.1%
750	48	0.4%
749	6	< 0.1%
748	8	0.1%
747	12	0.1%

propertyName
Categorical

HIGH CARDINALITY

Distinct count	697
Unique (%)	5.1%
Missing	0
Missing (%)	0.0%
Memory size	106.6 KiB

Batik	440
Alexan 100	400
Jackson Apartments	356
624 Yale	316
Sedona Apartments	296
Other values (692)	11836

Common Values
Length

Value	Count	Frequency (%)
Batik	440	3.2%
Alexan 100	400	2.9%
Jackson Apartments	356	2.6%
624 Yale	316	2.3%
Sedona Apartments	296	2.2%
Assembly118	288	2.1%
Met Tower	272	2.0%
STAZIONE25	264	1.9%
Saxton	252	1.8%
McKenzie	176	1.3%
Other values (687)	10584	77.6%

Length

Max length	45
Median length	11
Mean length	12.62943418
Min length	2

street
Categorical

HIGH CARDINALITY

Distinct count	697
Unique (%)	5.1%
Missing	0
Missing (%)	0.0%
Memory size	106.6 KiB

123 Broadway	440
100 Denny Way	400
2401 S Jackson St	356
624 Yale Ave N	316
8500 20th Ave NE	296
Other values (692)	11836

Common Values
Length

Value	Count	Frequency (%)
123 Broadway	440	3.2%
100 Denny Way	400	2.9%
2401 S Jackson St	356	2.6%
624 Yale Ave N	316	2.3%
8500 20th Ave NE	296	2.2%
4200 S Othello St	288	2.1%
1942-1942 Westlake Ave	272	2.0%
2615 25th Ave S	264	1.9%
520 Terry Ave	252	1.8%
2202 Eighth Ave	176	1.3%
Other values (687)	10584	77.6%

Length

Max length	38
Median length	15
Mean length	15.57248607
Min length	10

city
Categorical

Distinct count	4
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	106.6 KiB

Seattle	13603
Lake Forest Park	26
Burien	11
Shoreline	4

Common Values
Length

Value	Count	Frequency (%)
Seattle	13603	99.7%
Lake Forest Park	26	0.2%
Burien	11	0.1%
Shoreline	4	< 0.1%

Length

Max length	16
Median length	7
Mean length	7.016930519
Min length	6

state
Categorical

CONSTANT
REJECTED

Distinct count	1
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	106.6 KiB

WA	13644

Common Values
Length

Value	Count	Frequency (%)
WA	13644	100.0%

Length

Max length	2
Median length	2
Mean length	2
Min length	2

zipCode
Real number (ℝ_≥0)

Distinct count	32
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	98116.88199941366
Minimum	98101
Maximum	98199
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	98101
5-th percentile	98101
Q1	98108
median	98115
Q3	98122
95-th percentile	98144
Maximum	98199
Range	98
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	14.62209843
Coefficient of variation (CV)	0.0001490273451
Kurtosis	8.608362182
Mean	98116.882
Median Absolute Deviation (MAD)	7
Skewness	2.369625893
Sum	1338706738
Variance	213.8057626

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
98109	2482	18.2%
98122	1471	10.8%
98121	1463	10.7%
98101	1021	7.5%
98115	954	7.0%
98144	737	5.4%
98116	718	5.3%
98104	705	5.2%
98125	705	5.2%
98107	518	3.8%
Other values (22)	2870	21.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
98101	1021	7.5%
98102	159	1.2%
98103	505	3.7%
98104	705	5.2%
98105	344	2.5%

Value	Count	Frequency (%)
98199	58	0.4%
98198	15	0.1%
98188	85	0.6%
98178	25	0.2%
98177	1	< 0.1%

neighborhood
Categorical

HIGH CARDINALITY

Distinct count	87
Unique (%)	0.6%
Missing	4
Missing (%)	< 0.1%
Memory size	106.6 KiB

South Lake Union	1611
First Hill	1074
Belltown	993
Denny Triangle	956
Lower Queen Anne	840
Other values (82)	8166

Common Values
Length

Value	Count	Frequency (%)
South Lake Union	1611	11.8%
First Hill	1074	7.9%
Belltown	993	7.3%
Denny Triangle	956	7.0%
Lower Queen Anne	840	6.2%
Capitol Hill	737	5.4%
Ballard	490	3.6%
Atlantic	425	3.1%
Brighton	356	2.6%
Roosevelt	350	2.6%
Other values (77)	5808	42.6%

Length

Max length	31
Median length	10
Mean length	11.57292583
Min length	3

reviewScore
Real number (ℝ_≥0)

ZEROS

Distinct count	5
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.5583406625622984
Minimum	0
Maximum	5
Zeros	9224
Zeros (%)	67.6%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	5
95-th percentile	5
Maximum	5
Range	5
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.264788044
Coefficient of variation (CV)	1.453333086
Kurtosis	-1.351812219
Mean	1.558340663
Median Absolute Deviation (MAD)	0
Skewness	0.7846450508
Sum	21262
Variance	5.129264885

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	9224	67.6%
5	3641	26.7%
4	738	5.4%
3	23	0.2%
2	18	0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	9224	67.6%
2	18	0.1%
3	23	0.2%
4	738	5.4%
5	3641	26.7%

Value	Count	Frequency (%)
5	3641	26.7%
4	738	5.4%
3	23	0.2%
2	18	0.1%
0	9224	67.6%

reviewCount
Real number (ℝ_≥0)

ZEROS

Distinct count	24
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.4695836997947818
Minimum	0
Maximum	150
Zeros	5516
Zeros (%)	40.4%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	15
Maximum	150
Range	150
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.751634553
Coefficient of variation (CV)	2.234168484
Kurtosis	139.4384503
Mean	3.4695837
Median Absolute Deviation (MAD)	1
Skewness	9.025237986
Sum	47339
Variance	60.08783825

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	5516	40.4%
1	2201	16.1%
2	1165	8.5%
5	941	6.9%
3	884	6.5%
4	720	5.3%
6	336	2.5%
8	284	2.1%
15	261	1.9%
23	199	1.5%
Other values (14)	1137	8.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5516	40.4%
1	2201	16.1%
2	1165	8.5%
3	884	6.5%
4	720	5.3%

Value	Count	Frequency (%)
150	14	0.1%
53	83	0.6%
24	84	0.6%
23	199	1.5%
22	13	0.1%

walkScore
Real number (ℝ_≥0)

Distinct count	75
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	90.7982996188801
Minimum	9
Maximum	100
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	9
5-th percentile	69
Q1	90
median	96
Q3	98
95-th percentile	99
Maximum	100
Range	91
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	12.17441151
Coefficient of variation (CV)	0.1340819328
Kurtosis	7.132671395
Mean	90.79829962
Median Absolute Deviation (MAD)	3
Skewness	-2.507152451
Sum	1238852
Variance	148.2162956

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
99	2285	16.7%
98	1438	10.5%
97	1366	10.0%
96	1106	8.1%
95	787	5.8%
92	695	5.1%
90	681	5.0%
100	672	4.9%
93	580	4.3%
89	389	2.9%
Other values (65)	3645	26.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
9	1	< 0.1%
10	1	< 0.1%
16	1	< 0.1%
19	1	< 0.1%
20	6	< 0.1%

Value	Count	Frequency (%)
100	672	4.9%
99	2285	16.7%
98	1438	10.5%
97	1366	10.0%
96	1106	8.1%

transitScore
Real number (ℝ_≥0)

ZEROS

Distinct count	67
Unique (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	77.04954558780416
Minimum	0
Maximum	100
Zeros	212
Zeros (%)	1.6%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	59
median	82
Q3	100
95-th percentile	100
Maximum	100
Range	100
Interquartile range (IQR)	41

Descriptive statistics

Standard deviation	20.85972055
Coefficient of variation (CV)	0.2707312599
Kurtosis	0.8524035019
Mean	77.04954559
Median Absolute Deviation (MAD)	18
Skewness	-0.7662133003
Sum	1051264
Variance	435.1279416

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	3923	28.8%
54	758	5.6%
82	602	4.4%
59	541	4.0%
66	474	3.5%
56	442	3.2%
70	437	3.2%
52	407	3.0%
64	405	3.0%
84	385	2.8%
Other values (57)	5270	38.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	212	1.6%
33	4	< 0.1%
34	1	< 0.1%
35	8	0.1%
36	1	< 0.1%

Value	Count	Frequency (%)
100	3923	28.8%
99	73	0.5%
98	9	0.1%
97	99	0.7%
96	72	0.5%

Unnamed: 0_y
Real number (ℝ_≥0)

Distinct count	10762
Unique (%)	78.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5480.078789211375
Minimum	0
Maximum	10761
Zeros	2
Zeros (%)	< 0.1%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	462
Q1	2532
median	5383.5
Q3	8705.25
95-th percentile	10408.85
Maximum	10761
Range	10761
Interquartile range (IQR)	6173.25

Descriptive statistics

Standard deviation	3352.311984
Coefficient of variation (CV)	0.6117269684
Kurtosis	-1.368434903
Mean	5480.078789
Median Absolute Deviation (MAD)	3056.5
Skewness	0.0159681242
Sum	74770195
Variance	11237995.64

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
0	2	< 0.1%
10547	2	< 0.1%
10587	2	< 0.1%
8824	2	< 0.1%
2640	2	< 0.1%
2685	2	< 0.1%
10579	2	< 0.1%
9606	2	< 0.1%
8832	2	< 0.1%
2648	2	< 0.1%
Other values (10752)	13624	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	2	< 0.1%
2	2	< 0.1%
3	2	< 0.1%
4	2	< 0.1%

Value	Count	Frequency (%)
10761	2	< 0.1%
10760	2	< 0.1%
10759	2	< 0.1%
10758	2	< 0.1%
10757	2	< 0.1%

bedRoomType
Categorical

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	106.6 KiB

Traditional	10842
Studio	2802

Common Values
Length

Value	Count	Frequency (%)
Traditional	10842	79.5%
Studio	2802	20.5%

Length

Max length	11
Median length	11
Mean length	9.973175022
Min length	6

bedRoomNumber
Real number (ℝ_≥0)

Distinct count	6
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.2837144532395193
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	2
Maximum	6
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.5061189284
Coefficient of variation (CV)	0.3942612994
Kurtosis	4.173943486
Mean	1.283714453
Median Absolute Deviation (MAD)	0
Skewness	1.786197531
Sum	17515
Variance	0.2561563697

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	10081	73.9%
2	3295	24.1%
3	239	1.8%
4	20	0.1%
5	7	0.1%
6	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	10081	73.9%
2	3295	24.1%
3	239	1.8%
4	20	0.1%
5	7	0.1%

Value	Count	Frequency (%)
6	2	< 0.1%
5	7	0.1%
4	20	0.1%
3	239	1.8%
2	3295	24.1%

baths
Real number (ℝ_≥0)

Distinct count	12
Unique (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.227792436235708
Minimum	0.0
Maximum	5.0
Zeros	17
Zeros (%)	0.1%
Memory size	106.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	5
Range	5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4417549202
Coefficient of variation (CV)	0.3597960919
Kurtosis	2.331313893
Mean	1.227792436
Median Absolute Deviation (MAD)	0
Skewness	1.660588025
Sum	16752
Variance	0.1951474095

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	10517	77.1%
2	2701	19.8%
1.5	243	1.8%
2.5	81	0.6%
3	53	0.4%
3.5	25	0.2%
0	17	0.1%
0.5	2	< 0.1%
4	2	< 0.1%
3.25	1	< 0.1%
Other values (2)	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	17	0.1%
0.5	2	< 0.1%
1	10517	77.1%
1.5	243	1.8%
2	2701	19.8%

Value	Count	Frequency (%)
5	1	< 0.1%
4	2	< 0.1%
3.5	25	0.2%
3.25	1	< 0.1%
3	53	0.4%

rent
Real number (ℝ_≥0)

MISSING

Distinct count	1846
Unique (%)	19.4%
Missing	4132
Missing (%)	30.3%
Infinite	0
Infinite (%)	0.0%

Mean	2363.2186711522286
Minimum	625.0
Maximum	15160.0
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	625
5-th percentile	1207
Q1	1720
median	2110
Q3	2703
95-th percentile	4045.7
Maximum	15160
Range	14535
Interquartile range (IQR)	983

Descriptive statistics

Standard deviation	1155.945331
Coefficient of variation (CV)	0.4891402328
Kurtosis	25.94459392
Mean	2363.218671
Median Absolute Deviation (MAD)	460
Skewness	3.825272383
Sum	22478936
Variance	1336209.608

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1350	63	0.5%
1695	52	0.4%
1895	47	0.3%
1899	47	0.3%
1900	46	0.3%
2250	45	0.3%
2095	40	0.3%
2000	40	0.3%
2700	39	0.3%
1850	39	0.3%
Other values (1836)	9054	66.4%
(Missing)	4132	30.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
625	1	< 0.1%
645	1	< 0.1%
650	1	< 0.1%
750	1	< 0.1%
763	1	< 0.1%

Value	Count	Frequency (%)
15160	4	< 0.1%
14860	4	< 0.1%
13160	4	< 0.1%
12500	1	< 0.1%
11660	4	< 0.1%

sqft
Real number (ℝ_≥0)

MISSING

Distinct count	1524
Unique (%)	11.3%
Missing	213
Missing (%)	1.6%
Infinite	0
Infinite (%)	0.0%

Mean	747.04910282183
Minimum	90.0
Maximum	4380.0
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	90
5-th percentile	317
Q1	567
median	696
Q3	904
95-th percentile	1227
Maximum	4380
Range	4290
Interquartile range (IQR)	337

Descriptive statistics

Standard deviation	298.8450342
Coefficient of variation (CV)	0.4000339911
Kurtosis	6.579931398
Mean	747.0491028
Median Absolute Deviation (MAD)	164
Skewness	1.506451907
Sum	10033616.5
Variance	89308.35446

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
600	104	0.8%
670	83	0.6%
1000	71	0.5%
589	70	0.5%
573	64	0.5%
633	59	0.4%
650	59	0.4%
656	57	0.4%
700	56	0.4%
665	55	0.4%
Other values (1514)	12753	93.5%
(Missing)	213	1.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
90	2	< 0.1%
145	10	0.1%
147	1	< 0.1%
149	4	< 0.1%
153	1	< 0.1%

Value	Count	Frequency (%)
4380	1	< 0.1%
3380	1	< 0.1%
3000	2	< 0.1%
2950	1	< 0.1%
2720	1	< 0.1%

availability
Boolean

Distinct count	2
Unique (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	13.3 KiB

False	8028
True	5616

Frequency Table

Value	Count	Frequency (%)
False	8028	58.8%
True	5616	41.2%

deposit
Real number (ℝ_≥0)

MISSING

Distinct count	70
Unique (%)	36.5%
Missing	13452
Missing (%)	98.6%
Infinite	0
Infinite (%)	0.0%

Mean	1567.1510416666667
Minimum	100.0
Maximum	6700.0
Zeros	0
Zeros (%)	0.0%
Memory size	106.6 KiB

Quantile statistics

Minimum	100
5-th percentile	400
Q1	887.5
median	1287.5
Q3	2000
95-th percentile	3632.75
Maximum	6700
Range	6600
Interquartile range (IQR)	1112.5

Descriptive statistics

Standard deviation	1043.523759
Coefficient of variation (CV)	0.6658731235
Kurtosis	3.339982309
Mean	1567.151042
Median Absolute Deviation (MAD)	537.5
Skewness	1.550877642
Sum	300893
Variance	1088941.836

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1000	28	0.2%
1500	16	0.1%
500	11	0.1%
1200	9	0.1%
2000	8	0.1%
750	8	0.1%
800	7	0.1%
400	6	< 0.1%
1400	5	< 0.1%
350	4	< 0.1%
Other values (60)	90	0.7%
(Missing)	13452	98.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
100	1	< 0.1%
250	1	< 0.1%
300	1	< 0.1%
350	4	< 0.1%
400	6	< 0.1%

Value	Count	Frequency (%)
6700	1	< 0.1%
5000	1	< 0.1%
4700	1	< 0.1%
4400	2	< 0.1%
4200	1	< 0.1%

unit
Categorical

HIGH CARDINALITY
MISSING

Distinct count	1726
Unique (%)	38.1%
Missing	9113
Missing (%)	66.8%
Memory size	106.6 KiB

406	39
306	28
509	26
304	25
302	25
Other values (1721)	4388

Common Values
Length

Value	Count	Frequency (%)
406	39	0.3%
306	28	0.2%
509	26	0.2%
304	25	0.2%
302	25	0.2%
301	23	0.2%
321	21	0.2%
207	21	0.2%
501	21	0.2%
311	21	0.2%
Other values (1716)	4281	31.4%
(Missing)	9113	66.8%

Length

Max length	20
Median length	3
Mean length	3.250219877
Min length	1

leaseLength
Categorical

MISSING

Distinct count	4
Unique (%)	2.4%
Missing	13480
Missing (%)	98.8%
Memory size	106.6 KiB

12	145
6	9
1	7
3	3

Common Values
Length

Value	Count	Frequency (%)
12	145	1.1%
6	9	0.1%
1	7	0.1%
3	3	< 0.1%
(Missing)	13480	98.8%

Length

Max length	4
Median length	3
Mean length	3.010627382
Min length	3

name
Categorical

HIGH CARDINALITY
MISSING

Distinct count	4476
Unique (%)	33.6%
Missing	335
Missing (%)	2.5%
Memory size	106.6 KiB

Studio	405
A4	102
1 Bedroom	101
1x1	99
Standard Studio	95
Other values (4471)	12507

Common Values
Length

Value	Count	Frequency (%)
Studio	405	3.0%
A4	102	0.7%
1 Bedroom	101	0.7%
1x1	99	0.7%
Standard Studio	95	0.7%
A1	95	0.7%
A2	92	0.7%
2x2	91	0.7%
A3	70	0.5%
S1	67	0.5%
Other values (4466)	12092	88.6%
(Missing)	335	2.5%

Length

Max length	50
Median length	8
Mean length	9.647903841
Min length	1

new
Categorical

MISSING

Distinct count	1
Unique (%)	0.2%
Missing	13121
Missing (%)	96.2%
Memory size	106.6 KiB

New	523

Common Values
Length

Value	Count	Frequency (%)
New	523	3.8%
(Missing)	13121	96.2%

Length

Max length	3
Median length	3
Mean length	3
Min length	3

applyNow
Categorical

MISSING

Distinct count	2
Unique (%)	0.6%
Missing	13309
Missing (%)	97.5%
Memory size	106.6 KiB

Request To Apply	323
Apply Now	12

Common Values
Length

Value	Count	Frequency (%)
Request To Apply	323	2.4%
Apply Now	12	0.1%
(Missing)	13309	97.5%

Length

Max length	16
Median length	3
Mean length	3.313031369
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	propertyName	street	city	state	zipCode	neighborhood	walkScore	transitScore	Unnamed: 0_y	bedRoomType	bedRoomNumber	baths	rent	sqft	availability	deposit	unit	leaseLength	name	new	applyNow
0	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	0	Studio	1	1.0	1790.0	465.0	True	NaN	NaN	NaN	S.2.W	NaN	NaN
1	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	1	Studio	1	1.0	1905.0	475.0	True	NaN	NaN	NaN	S.1.E	NaN	NaN
2	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	2	Studio	1	1.0	1920.0	570.0	True	NaN	NaN	NaN	S.3.S	NaN	NaN
3	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	3	Traditional	1	1.0	2060.0	509.0	True	NaN	NaN	NaN	0.18.W	NaN	NaN
4	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	4	Traditional	1	1.0	2070.0	657.0	True	NaN	NaN	NaN	0.17.W	NaN	NaN
5	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	5	Traditional	1	1.0	2075.0	596.0	True	NaN	NaN	NaN	0.4.E	NaN	NaN
6	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	6	Traditional	1	1.0	2075.0	597.0	True	NaN	NaN	NaN	0.1.2	NaN	NaN
7	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	7	Traditional	1	1.0	2075.0	598.0	True	NaN	NaN	NaN	0.6.W	NaN	NaN
8	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	8	Traditional	1	1.0	2075.0	620.0	True	NaN	NaN	NaN	0.9.W	NaN	NaN
9	Jackson Apartments	2401 S Jackson St	Seattle	WA	98144	Atlantic	90	70	9	Traditional	1	1.0	2075.0	629.0	True	NaN	NaN	NaN	0.20.S	NaN	NaN

Last rows

	Unnamed: 0_x	propertyName	street	city	state	zipCode	neighborhood	walkScore	transitScore	Unnamed: 0_y	bedRoomType	bedRoomNumber	baths	rent	sqft	availability	deposit	unit	leaseLength	name	new	applyNow
13634	726	3 br, 1 bath House - 8533 18th Ave NW	8533 18th Ave NW	Seattle	WA	98117	Crown Hill	85	54	10506	Traditional	3	1.0	3600.0	1550.0	True	NaN	NaN	NaN	NaN	NaN	NaN
13635	727	1320 14th Ave S	1320 14th Ave S	Seattle	WA	98144	Seattle	74	89	10507	Traditional	2	1.0	1695.0	750.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13636	729	10306 Holman Rd N	10306 Holman Rd N	Seattle	WA	98133	Greenwood	85	57	10517	Studio	1	1.0	1100.0	400.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13637	730	311 6th Ave S	311 6th Ave S	Seattle	WA	98104	Chinatown	99	100	10518	Studio	1	1.0	1195.0	386.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13638	731	1307 N Northgate Way	1307 N Northgate Way	Seattle	WA	98133	North College Park	87	61	10519	Studio	1	1.0	1295.0	288.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13639	732	3631 13th Ave W	3631 13th Ave W	Seattle	WA	98119	Queen Anne	69	56	10520	Traditional	2	1.0	1600.0	900.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13640	733	500 W Mercer St	500 W Mercer St	Seattle	WA	98119	Lower Queen Anne	84	63	10521	Traditional	2	1.0	2400.0	1180.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13641	735	6 br, 3 bath House - 12705 27th Ave NE	12705 27th Ave NE	Seattle	WA	98125	Lake City	88	60	10632	Traditional	6	3.0	3150.0	2400.0	True	NaN	NaN	NaN	NaN	NaN	NaN
13642	736	3230 SW Avalon Way	3230 SW Avalon Way	Seattle	WA	98126	Fairmount Park	78	58	10633	Traditional	1	1.0	1395.0	605.0	True	NaN	NaN	NaN	NaN	NaN	Request To Apply
13643	737	7719 Renton Ave S	7719 Renton Ave S	Seattle	WA	98118	Brighton	76	64	10634	Traditional	2	1.0	1725.0	780.0	True	NaN	NaN	NaN	NaN	NaN	NaN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows